Pandas Profiling Report

Dataset statistics

Number of variables	20
Number of observations	97463
Missing cells	158882
Missing cells (%)	8.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	14.9 MiB
Average record size in memory	160.0 B

Variable types

Numeric	6
Categorical	5
Text	6
Unsupported	1
DateTime	2

Alerts

`Fiscal_Year` has constant value ""	Constant
`CheckVoidDt` has constant value ""	Constant
`ObjectId` is highly overall correlated with `Budget_Type` and 1 other fields	High correlation
`InvoiceID` is highly overall correlated with `CheckID`	High correlation
`InvoiceAmt` is highly overall correlated with `DistributionAmt` and 1 other fields	High correlation
`DistributionAmt` is highly overall correlated with `InvoiceAmt`	High correlation
`CheckID` is highly overall correlated with `InvoiceID`	High correlation
`CheckAmt` is highly overall correlated with `InvoiceAmt`	High correlation
`Budget_Type` is highly overall correlated with `ObjectId` and 1 other fields	High correlation
`Agency_Name` is highly overall correlated with `ObjectId` and 1 other fields	High correlation
`Budget_Type` is highly imbalanced (71.5%)	Imbalance
`Category` is highly imbalanced (59.0%)	Imbalance
`DepartmentName` has 5230 (5.4%) missing values	Missing
`Sub_DepartmentName` has 56189 (57.7%) missing values	Missing
`Stimulus_Type` has 97463 (100.0%) missing values	Missing
`InvoiceAmt` is highly skewed (γ1 = 29.3232093)	Skewed
`DistributionAmt` is highly skewed (γ1 = 60.85704035)	Skewed
`ObjectId` is uniformly distributed	Uniform
`ObjectId` has unique values	Unique
`Stimulus_Type` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2023-12-31 13:39:03.563754
Analysis finished	2023-12-31 13:39:19.610514
Duration	16.05 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

ObjectId
Real number (ℝ)

HIGH CORRELATION UNIFORM UNIQUE

Distinct	97463
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	48732

Minimum	1
Maximum	97463
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	761.6 KiB

Quantile statistics

Minimum	1
5-th percentile	4874.1
Q1	24366.5
median	48732
Q3	73097.5
95-th percentile	92589.9
Maximum	97463
Range	97462
Interquartile range (IQR)	48731

Descriptive statistics

Standard deviation	28135.289
Coefficient of variation (CV)	0.57734731
Kurtosis	-1.2
Mean	48732
Median Absolute Deviation (MAD)	24366
Skewness	0
Sum	4.7495669 × 10⁹
Variance	7.9159449 × 10⁸
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
64973	1	< 0.1%
64982	1	< 0.1%
64981	1	< 0.1%
64980	1	< 0.1%
64979	1	< 0.1%
64978	1	< 0.1%
64977	1	< 0.1%
64976	1	< 0.1%
64975	1	< 0.1%
Other values (97453)	97453	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
97463	1	< 0.1%
97462	1	< 0.1%
97461	1	< 0.1%
97460	1	< 0.1%
97459	1	< 0.1%
97458	1	< 0.1%
97457	1	< 0.1%
97456	1	< 0.1%
97455	1	< 0.1%
97454	1	< 0.1%

Fiscal_Year
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	761.6 KiB

2016	97463

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	389852
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2016
2nd row	2016
3rd row	2016
4th row	2016
5th row	2016

Common Values

Value	Count	Frequency (%)
2016	97463	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2016	97463	100.0%

Most occurring characters

Value	Count	Frequency (%)
2	97463	25.0%
0	97463	25.0%
1	97463	25.0%
6	97463	25.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	389852	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	97463	25.0%
0	97463	25.0%
1	97463	25.0%
6	97463	25.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	389852	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	97463	25.0%
0	97463	25.0%
1	97463	25.0%
6	97463	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	389852	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	97463	25.0%
0	97463	25.0%
1	97463	25.0%
6	97463	25.0%

Budget_Type
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	761.6 KiB

Metro Government Operations	92626
Metro Government Capital	4837

Length

Max length	27
Median length	27
Mean length	26.851113
Min length	24

Characters and Unicode

Total characters	2616990
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Metro Government Capital
2nd row	Metro Government Capital
3rd row	Metro Government Capital
4th row	Metro Government Capital
5th row	Metro Government Capital

Common Values

Value	Count	Frequency (%)
Metro Government Operations	92626	95.0%
Metro Government Capital	4837	5.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
metro	97463	33.3%
government	97463	33.3%
operations	92626	31.7%
capital	4837	1.7%

Most occurring characters

Value	Count	Frequency (%)
e	385015	14.7%
t	292389	11.2%
n	287552	11.0%
r	287552	11.0%
o	287552	11.0%
	194926	7.4%
a	102300	3.9%
p	97463	3.7%
i	97463	3.7%
M	97463	3.7%
Other values (7)	487315	18.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2129675	81.4%
Uppercase Letter	292389	11.2%
Space Separator	194926	7.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	385015	18.1%
t	292389	13.7%
n	287552	13.5%
r	287552	13.5%
o	287552	13.5%
a	102300	4.8%
p	97463	4.6%
i	97463	4.6%
m	97463	4.6%
v	97463	4.6%
Other values (2)	97463	4.6%

Uppercase Letter

Value	Count	Frequency (%)
M	97463	33.3%
G	97463	33.3%
O	92626	31.7%
C	4837	1.7%

Space Separator

Value	Count	Frequency (%)
	194926	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2422064	92.6%
Common	194926	7.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	385015	15.9%
t	292389	12.1%
n	287552	11.9%
r	287552	11.9%
o	287552	11.9%
a	102300	4.2%
p	97463	4.0%
i	97463	4.0%
M	97463	4.0%
m	97463	4.0%
Other values (6)	389852	16.1%

Common

Value	Count	Frequency (%)
	194926	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2616990	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	385015	14.7%
t	292389	11.2%
n	287552	11.0%
r	287552	11.0%
o	287552	11.0%
	194926	7.4%
a	102300	3.9%
p	97463	3.7%
i	97463	3.7%
M	97463	3.7%
Other values (7)	487315	18.6%

Agency_Name
Categorical

HIGH CORRELATION

Distinct	37
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	761.6 KiB

Community Services	15787
Office of Management & Budget	12401
Parks & Recreation	11596
Public Works & Assets	6266
Louisville Zoo	5925
Other values (32)	45488

Length

Max length	46
Median length	36
Mean length	22.142608
Min length	7

Characters and Unicode

Total characters	2158085
Distinct characters	45
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Public Works & Assets Department
2nd row	Public Works & Assets Department
3rd row	Public Works & Assets Department
4th row	Public Works & Assets Department
5th row	Public Works & Assets Department

Common Values

Value	Count	Frequency (%)
Community Services	15787	16.2%
Office of Management & Budget	12401	12.7%
Parks & Recreation	11596	11.9%
Public Works & Assets	6266	6.4%
Louisville Zoo	5925	6.1%
Louisville Free Public Library	5180	5.3%
Louisville Metro Police Department	5026	5.2%
Emergency Services	4742	4.9%
Other Elected Officials	3691	3.8%
Develop Louisville	3627	3.7%
Other values (27)	23222	23.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	36837	12.1%
louisville	24956	8.2%
services	23976	7.8%
of	17003	5.6%
public	16503	5.4%
community	15787	5.2%
office	13038	4.3%
management	12437	4.1%
budget	12401	4.1%
parks	11596	3.8%
Other values (47)	120931	39.6%

Most occurring characters

Value	Count	Frequency (%)
e	259971	12.0%
	208002	9.6%
i	166453	7.7%
o	132687	6.1%
t	113463	5.3%
r	112674	5.2%
s	111340	5.2%
l	101531	4.7%
c	93272	4.3%
n	93156	4.3%
Other values (35)	765536	35.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1661267	77.0%
Uppercase Letter	251699	11.7%
Space Separator	208002	9.6%
Other Punctuation	37117	1.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	259971	15.6%
i	166453	10.0%
o	132687	8.0%
t	113463	6.8%
r	112674	6.8%
s	111340	6.7%
l	101531	6.1%
c	93272	5.6%
n	93156	5.6%
a	79109	4.8%
Other values (11)	397611	23.9%

Uppercase Letter

Value	Count	Frequency (%)
P	33728	13.4%
L	30441	12.1%
S	24013	9.5%
C	22031	8.8%
M	21519	8.5%
O	20420	8.1%
D	17384	6.9%
R	13837	5.5%
B	12401	4.9%
W	11323	4.5%
Other values (10)	44602	17.7%

Other Punctuation

Value	Count	Frequency (%)
&	36645	98.7%
'	244	0.7%
/	228	0.6%

Space Separator

Value	Count	Frequency (%)
	208002	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1912966	88.6%
Common	245119	11.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	259971	13.6%
i	166453	8.7%
o	132687	6.9%
t	113463	5.9%
r	112674	5.9%
s	111340	5.8%
l	101531	5.3%
c	93272	4.9%
n	93156	4.9%
a	79109	4.1%
Other values (31)	649310	33.9%

Common

Value	Count	Frequency (%)
	208002	84.9%
&	36645	14.9%
'	244	0.1%
/	228	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2158085	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	259971	12.0%
	208002	9.6%
i	166453	7.7%
o	132687	6.1%
t	113463	5.3%
r	112674	5.2%
s	111340	5.2%
l	101531	4.7%
c	93272	4.3%
n	93156	4.3%
Other values (35)	765536	35.5%

Sub_Agency_Name
Text

Distinct	515
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Memory size	761.6 KiB

Length

Max length	70
Median length	55
Mean length	20.604383
Min length	6

Characters and Unicode

Total characters	2008165
Distinct characters	73
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	119 ?
Unique (%)	0.1%

Sample

1st row	Bridge Repair and Replacement
2nd row	Bridge Repair and Replacement
3rd row	Bridge Repair and Replacement
4th row	Bridge Repair and Replacement
5th row	Bridge Repair and Replacement

Value	Count	Frequency (%)
	25770	10.0%
services	23567	9.1%
community	17189	6.7%
facilities	12856	5.0%
fleet	11338	4.4%
support	10004	3.9%
operations	6899	2.7%
maintenance	6099	2.4%
public	5608	2.2%
administrative	5107	2.0%
Other values (793)	133306	51.7%

Most occurring characters

Value	Count	Frequency (%)
e	200782	10.0%
i	197159	9.8%
	160280	8.0%
t	147326	7.3%
n	124696	6.2%
r	120317	6.0%
o	107652	5.4%
s	100349	5.0%
a	97947	4.9%
c	74402	3.7%
Other values (63)	677255	33.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1560306	77.7%
Uppercase Letter	246232	12.3%
Space Separator	160280	8.0%
Other Punctuation	29971	1.5%
Decimal Number	9279	0.5%
Close Punctuation	917	< 0.1%
Open Punctuation	917	< 0.1%
Dash Punctuation	263	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	200782	12.9%
i	197159	12.6%
t	147326	9.4%
n	124696	8.0%
r	120317	7.7%
o	107652	6.9%
s	100349	6.4%
a	97947	6.3%
c	74402	4.8%
l	69498	4.5%
Other values (16)	320178	20.5%

Uppercase Letter

Value	Count	Frequency (%)
S	45994	18.7%
C	31163	12.7%
F	30995	12.6%
P	20939	8.5%
A	18133	7.4%
O	15678	6.4%
D	12415	5.0%
M	11268	4.6%
R	10031	4.1%
B	7776	3.2%
Other values (16)	41840	17.0%

Decimal Number

Value	Count	Frequency (%)
1	4540	48.9%
6	1737	18.7%
5	865	9.3%
9	816	8.8%
0	478	5.2%
2	366	3.9%
4	321	3.5%
8	70	0.8%
3	64	0.7%
7	22	0.2%

Other Punctuation

Value	Count	Frequency (%)
&	25700	85.7%
/	1865	6.2%
'	1626	5.4%
,	604	2.0%
.	167	0.6%
#	8	< 0.1%
:	1	< 0.1%

Space Separator

Value	Count	Frequency (%)
	160280	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	917	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	917	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	263	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1806538	90.0%
Common	201627	10.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	200782	11.1%
i	197159	10.9%
t	147326	8.2%
n	124696	6.9%
r	120317	6.7%
o	107652	6.0%
s	100349	5.6%
a	97947	5.4%
c	74402	4.1%
l	69498	3.8%
Other values (42)	566410	31.4%

Common

Value	Count	Frequency (%)
	160280	79.5%
&	25700	12.7%
1	4540	2.3%
/	1865	0.9%
6	1737	0.9%
'	1626	0.8%
)	917	0.5%
(	917	0.5%
5	865	0.4%
9	816	0.4%
Other values (11)	2364	1.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2008165	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	200782	10.0%
i	197159	9.8%
	160280	8.0%
t	147326	7.3%
n	124696	6.2%
r	120317	6.0%
o	107652	5.4%
s	100349	5.0%
a	97947	4.9%
c	74402	3.7%
Other values (63)	677255	33.7%

DepartmentName
Text

MISSING

Distinct	252
Distinct (%)	0.3%
Missing	5230
Missing (%)	5.4%
Memory size	761.6 KiB

Length

Max length	42
Median length	33
Mean length	17.809558
Min length	3

Characters and Unicode

Total characters	1642629
Distinct characters	67
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	15 ?
Unique (%)	< 0.1%

Sample

1st row	Finance & Administration
2nd row	Finance & Administration
3rd row	Finance & Administration
4th row	Finance & Administration
5th row	Finance & Administration

Value	Count	Frequency (%)
services	15357	7.5%
	14634	7.2%
management	10262	5.0%
facilities	9488	4.6%
self	6151	3.0%
sufficiency	6151	3.0%
maintenance	5259	2.6%
operations	4493	2.2%
policy	3830	1.9%
advocacy	3792	1.9%
Other values (349)	124962	61.1%

Most occurring characters

Value	Count	Frequency (%)
e	188832	11.5%
i	159513	9.7%
n	118293	7.2%
	112146	6.8%
a	110145	6.7%
t	96229	5.9%
c	87291	5.3%
r	84182	5.1%
s	71562	4.4%
o	67989	4.1%
Other values (57)	546447	33.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1300709	79.2%
Uppercase Letter	207512	12.6%
Space Separator	112146	6.8%
Other Punctuation	20010	1.2%
Decimal Number	2246	0.1%
Open Punctuation	3	< 0.1%
Close Punctuation	3	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	188832	14.5%
i	159513	12.3%
n	118293	9.1%
a	110145	8.5%
t	96229	7.4%
c	87291	6.7%
r	84182	6.5%
s	71562	5.5%
o	67989	5.2%
l	67963	5.2%
Other values (16)	248710	19.1%

Uppercase Letter

Value	Count	Frequency (%)
S	42527	20.5%
M	23990	11.6%
A	19565	9.4%
F	18942	9.1%
P	15706	7.6%
C	10534	5.1%
O	9127	4.4%
D	8755	4.2%
R	8271	4.0%
G	7188	3.5%
Other values (13)	42907	20.7%

Decimal Number

Value	Count	Frequency (%)
1	702	31.3%
2	451	20.1%
5	215	9.6%
4	186	8.3%
3	182	8.1%
9	153	6.8%
7	110	4.9%
6	107	4.8%
0	73	3.3%
8	67	3.0%

Other Punctuation

Value	Count	Frequency (%)
&	14633	73.1%
/	2407	12.0%
'	2060	10.3%
,	907	4.5%
?	3	< 0.1%

Space Separator

Value	Count	Frequency (%)
	112146	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	3	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	3	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1508221	91.8%
Common	134408	8.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	188832	12.5%
i	159513	10.6%
n	118293	7.8%
a	110145	7.3%
t	96229	6.4%
c	87291	5.8%
r	84182	5.6%
s	71562	4.7%
o	67989	4.5%
l	67963	4.5%
Other values (39)	456222	30.2%

Common

Value	Count	Frequency (%)
	112146	83.4%
&	14633	10.9%
/	2407	1.8%
'	2060	1.5%
,	907	0.7%
1	702	0.5%
2	451	0.3%
5	215	0.2%
4	186	0.1%
3	182	0.1%
Other values (8)	519	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1642629	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	188832	11.5%
i	159513	9.7%
n	118293	7.2%
	112146	6.8%
a	110145	6.7%
t	96229	5.9%
c	87291	5.3%
r	84182	5.1%
s	71562	4.4%
o	67989	4.1%
Other values (57)	546447	33.3%

Sub_DepartmentName
Text

MISSING

Distinct	89
Distinct (%)	0.2%
Missing	56189
Missing (%)	57.7%
Memory size	761.6 KiB

Length

Max length	43
Median length	38
Mean length	23.512599
Min length	8

Characters and Unicode

Total characters	970459
Distinct characters	58
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	5 ?
Unique (%)	< 0.1%

Sample

1st row	Finance/Administrative Support
2nd row	Finance/Administrative Support
3rd row	Finance/Administrative Support
4th row	Finance/Administrative Support
5th row	Finance/Administrative Support

Value	Count	Frequency (%)
management	8228	6.9%
facilities	8174	6.9%
services	7639	6.4%
	6542	5.5%
administration	5544	4.7%
care	4968	4.2%
of	4808	4.0%
grant	4769	4.0%
continuum	4744	4.0%
support	4451	3.7%
Other values (136)	59031	49.6%

Most occurring characters

Value	Count	Frequency (%)
e	96884	10.0%
i	95670	9.9%
n	86352	8.9%
	77624	8.0%
t	75992	7.8%
a	65111	6.7%
r	56286	5.8%
s	46957	4.8%
o	42660	4.4%
m	35129	3.6%
Other values (48)	291794	30.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	761842	78.5%
Uppercase Letter	120769	12.4%
Space Separator	77624	8.0%
Other Punctuation	9009	0.9%
Dash Punctuation	1183	0.1%
Open Punctuation	16	< 0.1%
Close Punctuation	16	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	96884	12.7%
i	95670	12.6%
n	86352	11.3%
t	75992	10.0%
a	65111	8.5%
r	56286	7.4%
s	46957	6.2%
o	42660	5.6%
m	35129	4.6%
l	31422	4.1%
Other values (16)	129379	17.0%

Uppercase Letter

Value	Count	Frequency (%)
S	21503	17.8%
F	19090	15.8%
C	16973	14.1%
M	13399	11.1%
A	10442	8.6%
G	8170	6.8%
P	8081	6.7%
E	3728	3.1%
I	3529	2.9%
V	3178	2.6%
Other values (13)	12676	10.5%

Other Punctuation

Value	Count	Frequency (%)
&	6318	70.1%
/	2460	27.3%
?	224	2.5%
.	6	0.1%
'	1	< 0.1%

Space Separator

Value	Count	Frequency (%)
	77624	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1183	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	16	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	16	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	882611	90.9%
Common	87848	9.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	96884	11.0%
i	95670	10.8%
n	86352	9.8%
t	75992	8.6%
a	65111	7.4%
r	56286	6.4%
s	46957	5.3%
o	42660	4.8%
m	35129	4.0%
l	31422	3.6%
Other values (39)	250148	28.3%

Common

Value	Count	Frequency (%)
	77624	88.4%
&	6318	7.2%
/	2460	2.8%
-	1183	1.3%
?	224	0.3%
(	16	< 0.1%
)	16	< 0.1%
.	6	< 0.1%
'	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	970459	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	96884	10.0%
i	95670	9.9%
n	86352	8.9%
	77624	8.0%
t	75992	7.8%
a	65111	6.7%
r	56286	5.8%
s	46957	4.8%
o	42660	4.4%
m	35129	3.6%
Other values (48)	291794	30.1%

Category
Categorical

IMBALANCE

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	761.6 KiB

Contractual Services	59109
Supplies	33986
Direct Reimbursements	2443
Equipment/Capital Outlay	1557
Other Expenses	308
Other values (3)	60

Length

Max length	24
Median length	20
Mean length	15.886306
Min length	8

Characters and Unicode

Total characters	1548327
Distinct characters	31
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Contractual Services
2nd row	Contractual Services
3rd row	Contractual Services
4th row	Contractual Services
5th row	Contractual Services

Common Values

Value	Count	Frequency (%)
Contractual Services	59109	60.6%
Supplies	33986	34.9%
Direct Reimbursements	2443	2.5%
Equipment/Capital Outlay	1557	1.6%
Other Expenses	308	0.3%
Interdepartment Charges	39	< 0.1%
Personnel Services	20	< 0.1%
Interagency Charges	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
services	59129	36.7%
contractual	59109	36.7%
supplies	33986	21.1%
direct	2443	1.5%
reimbursements	2443	1.5%
equipment/capital	1557	1.0%
outlay	1557	1.0%
other	308	0.2%
expenses	308	0.2%
charges	40	< 0.1%
Other values (3)	60	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	164696	10.6%
t	128201	8.3%
r	123571	8.0%
a	122969	7.9%
c	120682	7.8%
i	101115	6.5%
s	98677	6.4%
u	98652	6.4%
l	96229	6.2%
S	93115	6.0%
Other values (21)	400420	25.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1320796	85.3%
Uppercase Letter	162497	10.5%
Space Separator	63477	4.1%
Other Punctuation	1557	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	164696	12.5%
t	128201	9.7%
r	123571	9.4%
a	122969	9.3%
c	120682	9.1%
i	101115	7.7%
s	98677	7.5%
u	98652	7.5%
l	96229	7.3%
p	71433	5.4%
Other values (11)	194571	14.7%

Uppercase Letter

Value	Count	Frequency (%)
S	93115	57.3%
C	60706	37.4%
D	2443	1.5%
R	2443	1.5%
O	1865	1.1%
E	1865	1.1%
I	40	< 0.1%
P	20	< 0.1%

Space Separator

Value	Count	Frequency (%)
	63477	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	1557	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1483293	95.8%
Common	65034	4.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	164696	11.1%
t	128201	8.6%
r	123571	8.3%
a	122969	8.3%
c	120682	8.1%
i	101115	6.8%
s	98677	6.7%
u	98652	6.7%
l	96229	6.5%
S	93115	6.3%
Other values (19)	335386	22.6%

Common

Value	Count	Frequency (%)
	63477	97.6%
/	1557	2.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1548327	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	164696	10.6%
t	128201	8.3%
r	123571	8.0%
a	122969	7.9%
c	120682	7.8%
i	101115	6.5%
s	98677	6.4%
u	98652	6.4%
l	96229	6.2%
S	93115	6.0%
Other values (21)	400420	25.9%

Sub_Category
Text

Distinct	398
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	761.6 KiB

Length

Max length	51
Median length	38
Mean length	23.131291
Min length	4

Characters and Unicode

Total characters	2254445
Distinct characters	65
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	31 ?
Unique (%)	< 0.1%

Sample

1st row	Bridge Construction/ Repair Services
2nd row	Bridge Construction/ Repair Services
3rd row	Bridge Construction/ Repair Services
4th row	Bridge Construction/ Repair Services
5th row	Bridge Construction/ Repair Services

Value	Count	Frequency (%)
services	31663	12.2%
supplies	25805	10.0%
grant	12303	4.7%
assistance	7334	2.8%
community	6966	2.7%
equipment	6639	2.6%
office	6108	2.4%
professional	5907	2.3%
maintenance	5821	2.2%
	5434	2.1%
Other values (470)	145353	56.0%

Most occurring characters

Value	Count	Frequency (%)
e	241441	10.7%
i	196788	8.7%
	161870	7.2%
n	157420	7.0%
s	144319	6.4%
r	134444	6.0%
t	128618	5.7%
a	126423	5.6%
c	97837	4.3%
o	95736	4.2%
Other values (55)	769549	34.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1804642	80.0%
Uppercase Letter	263429	11.7%
Space Separator	161870	7.2%
Other Punctuation	22430	1.0%
Decimal Number	763	< 0.1%
Dash Punctuation	663	< 0.1%
Open Punctuation	324	< 0.1%
Close Punctuation	324	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	241441	13.4%
i	196788	10.9%
n	157420	8.7%
s	144319	8.0%
r	134444	7.4%
t	128618	7.1%
a	126423	7.0%
c	97837	5.4%
o	95736	5.3%
l	91969	5.1%
Other values (16)	389647	21.6%

Uppercase Letter

Value	Count	Frequency (%)
S	67872	25.8%
C	28165	10.7%
A	21830	8.3%
E	19439	7.4%
P	16605	6.3%
R	15627	5.9%
M	15489	5.9%
G	13959	5.3%
O	12121	4.6%
F	10758	4.1%
Other values (12)	41564	15.8%

Decimal Number

Value	Count	Frequency (%)
0	243	31.8%
1	170	22.3%
2	106	13.9%
5	53	6.9%
3	43	5.6%
4	37	4.8%
6	33	4.3%
9	30	3.9%
8	28	3.7%
7	20	2.6%

Other Punctuation

Value	Count	Frequency (%)
/	16477	73.5%
&	4943	22.0%
,	1010	4.5%

Space Separator

Value	Count	Frequency (%)
	161870	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	663	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	324	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	324	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2068071	91.7%
Common	186374	8.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	241441	11.7%
i	196788	9.5%
n	157420	7.6%
s	144319	7.0%
r	134444	6.5%
t	128618	6.2%
a	126423	6.1%
c	97837	4.7%
o	95736	4.6%
l	91969	4.4%
Other values (38)	653076	31.6%

Common

Value	Count	Frequency (%)
	161870	86.9%
/	16477	8.8%
&	4943	2.7%
,	1010	0.5%
-	663	0.4%
(	324	0.2%
)	324	0.2%
0	243	0.1%
1	170	0.1%
2	106	0.1%
Other values (7)	244	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2254445	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	241441	10.7%
i	196788	8.7%
	161870	7.2%
n	157420	7.0%
s	144319	6.4%
r	134444	6.0%
t	128618	5.7%
a	126423	5.6%
c	97837	4.3%
o	95736	4.2%
Other values (55)	769549	34.1%

Stimulus_Type
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	97463
Missing (%)	100.0%
Memory size	761.6 KiB

Funding_Source
Text

Distinct	68
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	761.6 KiB

Length

Max length	57
Median length	12
Mean length	12.806973
Min length	3

Characters and Unicode

Total characters	1248206
Distinct characters	64
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	County Road Aid
2nd row	County Road Aid
3rd row	County Road Aid
4th row	County Road Aid
5th row	County Road Aid

Value	Count	Frequency (%)
fund	76489	35.9%
general	73941	34.7%
shelter	4968	2.3%
plus	4968	2.3%
care	4968	2.3%
caa	2833	1.3%
2015	2130	1.0%
federally	1993	0.9%
funded	1993	0.9%
go	1899	0.9%
Other values (125)	37157	17.4%

Most occurring characters

Value	Count	Frequency (%)
e	183666	14.7%
n	161873	13.0%
	115876	9.3%
r	94935	7.6%
l	93064	7.5%
a	92335	7.4%
u	88561	7.1%
d	88365	7.1%
F	84320	6.8%
G	78022	6.3%
Other values (54)	167189	13.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	878145	70.4%
Uppercase Letter	235231	18.8%
Space Separator	115876	9.3%
Decimal Number	17095	1.4%
Dash Punctuation	1702	0.1%
Other Punctuation	133	< 0.1%
Open Punctuation	12	< 0.1%
Close Punctuation	12	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	183666	20.9%
n	161873	18.4%
r	94935	10.8%
l	93064	10.6%
a	92335	10.5%
u	88561	10.1%
d	88365	10.1%
t	17887	2.0%
i	10883	1.2%
s	10358	1.2%
Other values (15)	36218	4.1%

Uppercase Letter

Value	Count	Frequency (%)
F	84320	35.8%
G	78022	33.2%
C	14572	6.2%
A	11834	5.0%
P	8542	3.6%
S	8267	3.5%
M	5444	2.3%
O	3956	1.7%
E	3748	1.6%
B	3352	1.4%
Other values (13)	13174	5.6%

Decimal Number

Value	Count	Frequency (%)
1	4498	26.3%
0	4161	24.3%
2	3990	23.3%
5	3482	20.4%
4	592	3.5%
9	273	1.6%
3	89	0.5%
6	6	< 0.1%
7	4	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
/	106	79.7%
'	25	18.8%
.	2	1.5%

Space Separator

Value	Count	Frequency (%)
	115876	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1702	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	12	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	12	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1113376	89.2%
Common	134830	10.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	183666	16.5%
n	161873	14.5%
r	94935	8.5%
l	93064	8.4%
a	92335	8.3%
u	88561	8.0%
d	88365	7.9%
F	84320	7.6%
G	78022	7.0%
t	17887	1.6%
Other values (38)	130348	11.7%

Common

Value	Count	Frequency (%)
	115876	85.9%
1	4498	3.3%
0	4161	3.1%
2	3990	3.0%
5	3482	2.6%
-	1702	1.3%
4	592	0.4%
9	273	0.2%
/	106	0.1%
3	89	0.1%
Other values (6)	61	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1248206	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	183666	14.7%
n	161873	13.0%
	115876	9.3%
r	94935	7.6%
l	93064	7.5%
a	92335	7.4%
u	88561	7.1%
d	88365	7.1%
F	84320	6.8%
G	78022	6.3%
Other values (54)	167189	13.4%

Vendor_Name
Text

Distinct	5177
Distinct (%)	5.3%
Missing	0
Missing (%)	0.0%
Memory size	761.6 KiB

Length

Max length	93
Median length	62
Mean length	21.84787
Min length	2

Characters and Unicode

Total characters	2129359
Distinct characters	45
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1884 ?
Unique (%)	1.9%

Sample

1st row	HIGHWAY SAFETY SERVICES
2nd row	HIGHWAY SAFETY SERVICES
3rd row	HIGHWAY SAFETY SERVICES
4th row	HIGHWAY SAFETY SERVICES
5th row	HIGHWAY SAFETY SERVICES

Value	Count	Frequency (%)
inc	38584	11.4%
llc	10630	3.2%
	7562	2.2%
company	6730	2.0%
co	6257	1.9%
of	5402	1.6%
depot	4974	1.5%
office	4446	1.3%
supply	4202	1.2%
services	3106	0.9%
Other values (5832)	245296	72.7%

Most occurring characters

Value	Count	Frequency (%)
	239726	11.3%
E	186192	8.7%
I	164902	7.7%
N	161952	7.6%
R	136633	6.4%
C	135675	6.4%
A	135622	6.4%
O	128276	6.0%
S	124801	5.9%
L	119874	5.6%
Other values (35)	595706	28.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1873627	88.0%
Space Separator	239726	11.3%
Other Punctuation	12440	0.6%
Decimal Number	1734	0.1%
Dash Punctuation	1196	0.1%
Open Punctuation	318	< 0.1%
Close Punctuation	318	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	186192	9.9%
I	164902	8.8%
N	161952	8.6%
R	136633	7.3%
C	135675	7.2%
A	135622	7.2%
O	128276	6.8%
S	124801	6.7%
L	119874	6.4%
T	106373	5.7%
Other values (16)	473327	25.3%

Decimal Number

Value	Count	Frequency (%)
1	474	27.3%
9	267	15.4%
0	257	14.8%
8	217	12.5%
2	187	10.8%
4	157	9.1%
7	67	3.9%
3	46	2.7%
5	41	2.4%
6	21	1.2%

Other Punctuation

Value	Count	Frequency (%)
&	11755	94.5%
.	421	3.4%
/	155	1.2%
'	100	0.8%
#	9	0.1%

Space Separator

Value	Count	Frequency (%)
	239726	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1196	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	318	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	318	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1873627	88.0%
Common	255732	12.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	186192	9.9%
I	164902	8.8%
N	161952	8.6%
R	136633	7.3%
C	135675	7.2%
A	135622	7.2%
O	128276	6.8%
S	124801	6.7%
L	119874	6.4%
T	106373	5.7%
Other values (16)	473327	25.3%

Common

Value	Count	Frequency (%)
	239726	93.7%
&	11755	4.6%
-	1196	0.5%
1	474	0.2%
.	421	0.2%
(	318	0.1%
)	318	0.1%
9	267	0.1%
0	257	0.1%
8	217	0.1%
Other values (9)	783	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2129359	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	239726	11.3%
E	186192	8.7%
I	164902	7.7%
N	161952	7.6%
R	136633	6.4%
C	135675	6.4%
A	135622	6.4%
O	128276	6.0%
S	124801	5.9%
L	119874	5.6%
Other values (35)	595706	28.0%

InvoiceID
Real number (ℝ)

HIGH CORRELATION

Distinct	78363
Distinct (%)	80.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1669279.6

Minimum	1534328
Maximum	1724826
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	761.6 KiB

Quantile statistics

Minimum	1534328
5-th percentile	1625181
Q1	1644688.5
median	1669511
Q3	1693566.5
95-th percentile	1713899.9
Maximum	1724826
Range	190498
Interquartile range (IQR)	48878

Descriptive statistics

Standard deviation	28556.811
Coefficient of variation (CV)	0.017107267
Kurtosis	-1.13785
Mean	1669279.6
Median Absolute Deviation (MAD)	24516
Skewness	-0.003472627
Sum	1.6269299 × 10¹¹
Variance	8.1549145 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1647870	60	0.1%
1715811	42	< 0.1%
1651511	37	< 0.1%
1682576	37	< 0.1%
1674395	36	< 0.1%
1709592	35	< 0.1%
1655611	35	< 0.1%
1704776	35	< 0.1%
1695885	35	< 0.1%
1711564	35	< 0.1%
Other values (78353)	97076	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1534328	3	< 0.1%
1562460	3	< 0.1%
1574774	3	< 0.1%
1576636	1	< 0.1%
1578381	3	< 0.1%
1582040	3	< 0.1%
1588962	1	< 0.1%
1589092	1	< 0.1%
1592147	2	< 0.1%
1593516	1	< 0.1%

Value	Count	Frequency (%)
1724826	3	< 0.1%
1724357	1	< 0.1%
1724262	1	< 0.1%
1722877	1	< 0.1%
1722871	3	< 0.1%
1722862	1	< 0.1%
1722859	20	< 0.1%
1722821	1	< 0.1%
1722806	1	< 0.1%
1722799	1	< 0.1%

InvoiceDt
Date

Distinct	673
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	761.6 KiB

Minimum	2009-12-01 05:00:00+00:00
Maximum	2016-07-31 03:59:59+00:00

Histogram

Histogram with fixed size bins (bins=50)

InvoiceAmt
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	33924
Distinct (%)	34.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5259.9736

Minimum	-111520.18
Maximum	3297990
Zeros	0
Zeros (%)	0.0%
Negative	812
Negative (%)	0.8%
Memory size	761.6 KiB

Quantile statistics

Minimum	-111520.18
5-th percentile	15.5
Q1	90.91
median	315
Q3	1046.05
95-th percentile	14242.21
Maximum	3297990
Range	3409510.2
Interquartile range (IQR)	955.14

Descriptive statistics

Standard deviation	37983.479
Coefficient of variation (CV)	7.2212301
Kurtosis	1735.9058
Mean	5259.9736
Median Absolute Deviation (MAD)	270.37
Skewness	29.323209
Sum	5.126528 × 10⁸
Variance	1.4427447 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
400	1688	1.7%
300	842	0.9%
50	637	0.7%
100	585	0.6%
315	574	0.6%
30	562	0.6%
125	557	0.6%
500	353	0.4%
600	351	0.4%
200	318	0.3%
Other values (33914)	90996	93.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-111520.18	1	< 0.1%
-9465.41	1	< 0.1%
-8477.91	1	< 0.1%
-8068.5	2	< 0.1%
-7580	1	< 0.1%
-7319.69	1	< 0.1%
-7040.16	1	< 0.1%
-5831.44	1	< 0.1%
-5672.35	1	< 0.1%
-5172.68	1	< 0.1%

Value	Count	Frequency (%)
3297990	1	< 0.1%
3102226.8	1	< 0.1%
2968700	1	< 0.1%
1938891.75	1	< 0.1%
1896241.22	1	< 0.1%
1721522.1	1	< 0.1%
1441361	1	< 0.1%
1369957	1	< 0.1%
1331341	1	< 0.1%
998639	1	< 0.1%

DistributionAmt
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	39591
Distinct (%)	40.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2585.5885

Minimum	-430882.42
Maximum	3297990
Zeros	17
Zeros (%)	< 0.1%
Negative	2838
Negative (%)	2.9%
Memory size	761.6 KiB

Quantile statistics

Minimum	-430882.42
5-th percentile	4.58
Q1	49.13
median	210
Q3	661.48
95-th percentile	7740
Maximum	3297990
Range	3728872.4
Interquartile range (IQR)	612.35

Descriptive statistics

Standard deviation	28069.042
Coefficient of variation (CV)	10.855959
Kurtosis	5640.5785
Mean	2585.5885
Median Absolute Deviation (MAD)	190
Skewness	60.85704
Sum	2.5199921 × 10⁸
Variance	7.8787111 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
400	1678	1.7%
300	844	0.9%
50	655	0.7%
100	585	0.6%
315	560	0.6%
30	535	0.5%
125	511	0.5%
500	384	0.4%
600	352	0.4%
200	338	0.3%
Other values (39581)	91021	93.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-430882.42	1	< 0.1%
-317744.15	1	< 0.1%
-300000	1	< 0.1%
-267716.28	1	< 0.1%
-225000	1	< 0.1%
-132978.84	1	< 0.1%
-125000	1	< 0.1%
-111520.18	1	< 0.1%
-100643.04	1	< 0.1%
-100463.04	1	< 0.1%

Value	Count	Frequency (%)
3297990	1	< 0.1%
3102226.8	1	< 0.1%
2968700	1	< 0.1%
1938891.75	1	< 0.1%
1896241.22	1	< 0.1%
1721522.1	1	< 0.1%
1441361	1	< 0.1%
1369957	1	< 0.1%
1331341	1	< 0.1%
998639	1	< 0.1%

CheckID
Real number (ℝ)

HIGH CORRELATION

Distinct	45211
Distinct (%)	46.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	830373.01

Minimum	794385
Maximum	873879
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	761.6 KiB

Quantile statistics

Minimum	794385
5-th percentile	801133.1
Q1	814039.5
median	830657
Q3	846600
95-th percentile	859409
Maximum	873879
Range	79494
Interquartile range (IQR)	32560.5

Descriptive statistics

Standard deviation	18790.533
Coefficient of variation (CV)	0.022629026
Kurtosis	-1.1601541
Mean	830373.01
Median Absolute Deviation (MAD)	16134
Skewness	-0.0049543999
Sum	8.0930645 × 10¹⁰
Variance	3.5308412 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
832858	96	0.1%
803645	91	0.1%
843111	87	0.1%
840696	85	0.1%
836201	85	0.1%
809212	84	0.1%
858735	80	0.1%
829908	74	0.1%
843783	74	0.1%
815397	68	0.1%
Other values (45201)	96639	99.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
794385	1	< 0.1%
794426	1	< 0.1%
794541	1	< 0.1%
794719	1	< 0.1%
794735	1	< 0.1%
794748	1	< 0.1%
794756	1	< 0.1%
794758	1	< 0.1%
794775	1	< 0.1%
794877	1	< 0.1%

Value	Count	Frequency (%)
873879	1	< 0.1%
873873	2	< 0.1%
873830	1	< 0.1%
873820	1	< 0.1%
873387	2	< 0.1%
873380	1	< 0.1%
873362	1	< 0.1%
873217	1	< 0.1%
873205	1	< 0.1%
873032	2	< 0.1%

CheckDt
Date

Distinct	309
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	761.6 KiB

Minimum	2015-07-02 03:59:59+00:00
Maximum	2016-09-23 03:59:59+00:00

Histogram

Histogram with fixed size bins (bins=50)

CheckAmt
Real number (ℝ)

HIGH CORRELATION

Distinct	22752
Distinct (%)	23.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10624.83

Minimum	0
Maximum	3297990
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	761.6 KiB

Quantile statistics

Minimum	0
5-th percentile	51.3
Q1	309.21
median	976.5
Q3	4313.45
95-th percentile	33578.25
Maximum	3297990
Range	3297990
Interquartile range (IQR)	4004.24

Descriptive statistics

Standard deviation	51854.389
Coefficient of variation (CV)	4.8804913
Kurtosis	565.69533
Mean	10624.83
Median Absolute Deviation (MAD)	858.9
Skewness	16.499
Sum	1.0355278 × 10⁹
Variance	2.6888777 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
400	1691	1.7%
300	799	0.8%
100	414	0.4%
50	376	0.4%
600	369	0.4%
500	309	0.3%
550	213	0.2%
150	211	0.2%
200	205	0.2%
250	201	0.2%
Other values (22742)	92675	95.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
0.1	1	< 0.1%
0.13	4	< 0.1%
0.59	2	< 0.1%
0.61	5	< 0.1%
0.93	1	< 0.1%
1	14	< 0.1%
1.01	1	< 0.1%
1.05	1	< 0.1%
1.18	2	< 0.1%

Value	Count	Frequency (%)
3297990	1	< 0.1%
3102226.8	1	< 0.1%
2968700	1	< 0.1%
1938891.75	1	< 0.1%
1896241.22	1	< 0.1%
1721522.1	1	< 0.1%
1441361	1	< 0.1%
1433025	2	< 0.1%
1369957	1	< 0.1%
1098899.99	2	< 0.1%

CheckVoidDt
Categorical

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	761.6 KiB

1900/01/01 05:00:00+00	97463

Length

Max length	22
Median length	22
Mean length	22
Min length	22

Characters and Unicode

Total characters	2144186
Distinct characters	8
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1900/01/01 05:00:00+00
2nd row	1900/01/01 05:00:00+00
3rd row	1900/01/01 05:00:00+00
4th row	1900/01/01 05:00:00+00
5th row	1900/01/01 05:00:00+00

Common Values

Value	Count	Frequency (%)
1900/01/01 05:00:00+00	97463	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1900/01/01	97463	50.0%
05:00:00+00	97463	50.0%

Most occurring characters

Value	Count	Frequency (%)
0	1072093	50.0%
1	292389	13.6%
/	194926	9.1%
:	194926	9.1%
9	97463	4.5%
	97463	4.5%
5	97463	4.5%
+	97463	4.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1559408	72.7%
Other Punctuation	389852	18.2%
Space Separator	97463	4.5%
Math Symbol	97463	4.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1072093	68.8%
1	292389	18.8%
9	97463	6.2%
5	97463	6.2%

Other Punctuation

Value	Count	Frequency (%)
/	194926	50.0%
:	194926	50.0%

Space Separator

Value	Count	Frequency (%)
	97463	100.0%

Math Symbol

Value	Count	Frequency (%)
+	97463	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2144186	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1072093	50.0%
1	292389	13.6%
/	194926	9.1%
:	194926	9.1%
9	97463	4.5%
	97463	4.5%
5	97463	4.5%
+	97463	4.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2144186	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1072093	50.0%
1	292389	13.6%
/	194926	9.1%
:	194926	9.1%
9	97463	4.5%
	97463	4.5%
5	97463	4.5%
+	97463	4.5%

Auto

Heatmap
Table

	ObjectId	InvoiceID	InvoiceAmt	DistributionAmt	CheckID	CheckAmt	Budget_Type	Agency_Name	Category
ObjectId	1.000	-0.024	-0.067	-0.088	-0.020	0.047	0.685	0.680	0.223
InvoiceID	-0.024	1.000	0.008	0.004	0.992	0.017	0.042	0.044	0.025
InvoiceAmt	-0.067	0.008	1.000	0.816	0.010	0.615	0.077	0.123	0.024
DistributionAmt	-0.088	0.004	0.816	1.000	-0.001	0.480	0.063	0.069	0.014
CheckID	-0.020	0.992	0.010	-0.001	1.000	0.029	0.045	0.057	0.026
CheckAmt	0.047	0.017	0.615	0.480	0.029	1.000	0.140	0.136	0.028
Budget_Type	0.685	0.042	0.077	0.063	0.045	0.140	1.000	0.736	0.232
Agency_Name	0.680	0.044	0.123	0.069	0.057	0.136	0.736	1.000	0.317
Category	0.223	0.025	0.024	0.014	0.026	0.028	0.232	0.317	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	ObjectId	Fiscal_Year	Budget_Type	Agency_Name	Sub_Agency_Name	DepartmentName	Sub_DepartmentName	Category	Sub_Category	Stimulus_Type	Funding_Source	Vendor_Name	InvoiceID	InvoiceDt	InvoiceAmt	DistributionAmt	CheckID	CheckDt	CheckAmt	CheckVoidDt
0	1	2016	Metro Government Capital	Public Works & Assets Department	Bridge Repair and Replacement	NaN	NaN	Contractual Services	Bridge Construction/ Repair Services	NaN	County Road Aid	HIGHWAY SAFETY SERVICES	1643303	2015/09/30 03:59:59+00	5415.0	5415.0	815529	2015/10/26 03:59:59+00	7580.00	1900/01/01 05:00:00+00
1	2	2016	Metro Government Capital	Public Works & Assets Department	Bridge Repair and Replacement	NaN	NaN	Contractual Services	Bridge Construction/ Repair Services	NaN	County Road Aid	HIGHWAY SAFETY SERVICES	1627006	2015/07/31 03:59:59+00	5595.5	5595.5	807288	2015/09/14 03:59:59+00	5595.50	1900/01/01 05:00:00+00
2	3	2016	Metro Government Capital	Public Works & Assets Department	Bridge Repair and Replacement	NaN	NaN	Contractual Services	Bridge Construction/ Repair Services	NaN	County Road Aid	HIGHWAY SAFETY SERVICES	1634875	2015/08/31 03:59:59+00	5595.5	5595.5	809808	2015/09/25 03:59:59+00	7829.40	1900/01/01 05:00:00+00
3	4	2016	Metro Government Capital	Public Works & Assets Department	Bridge Repair and Replacement	NaN	NaN	Contractual Services	Bridge Construction/ Repair Services	NaN	County Road Aid	HIGHWAY SAFETY SERVICES	1619191	2015/06/30 03:59:59+00	5415.0	5415.0	801824	2015/08/12 03:59:59+00	5415.00	1900/01/01 05:00:00+00
4	5	2016	Metro Government Capital	Public Works & Assets Department	Bridge Repair and Replacement	NaN	NaN	Contractual Services	Bridge Construction/ Repair Services	NaN	County Road Aid	HIGHWAY SAFETY SERVICES	1675119	2016/01/31 05:00:00+00	5595.5	5595.5	836449	2016/02/25 05:00:00+00	6948.15	1900/01/01 05:00:00+00
5	6	2016	Metro Government Capital	Public Works & Assets Department	Bridge Repair and Replacement	NaN	NaN	Contractual Services	Bridge Construction/ Repair Services	NaN	County Road Aid	HIGHWAY SAFETY SERVICES	1675126	2016/01/31 05:00:00+00	62.0	62.0	836449	2016/02/25 05:00:00+00	6948.15	1900/01/01 05:00:00+00
6	7	2016	Metro Government Capital	Public Works & Assets Department	Bridge Repair and Replacement	NaN	NaN	Contractual Services	Bridge Construction/ Repair Services	NaN	County Road Aid	HIGHWAY SAFETY SERVICES	1668154	2015/12/31 05:00:00+00	5595.5	5595.5	830801	2016/01/25 05:00:00+00	7730.65	1900/01/01 05:00:00+00
7	8	2016	Metro Government Capital	Public Works & Assets Department	Bridge Repair and Replacement	NaN	NaN	Contractual Services	Bridge Construction/ Repair Services	NaN	County Road Aid	HIGHWAY SAFETY SERVICES	1659333	2015/11/30 05:00:00+00	5415.0	5415.0	826709	2015/12/28 05:00:00+00	10188.50	1900/01/01 05:00:00+00
8	9	2016	Metro Government Capital	Public Works & Assets Department	Bridge Repair and Replacement	NaN	NaN	Contractual Services	Bridge Construction/ Repair Services	NaN	County Road Aid	HIGHWAY SAFETY SERVICES	1682886	2016/02/29 05:00:00+00	5234.5	5234.5	841617	2016/03/25 03:59:59+00	7597.85	1900/01/01 05:00:00+00
9	10	2016	Metro Government Capital	Public Works & Assets Department	Bridge Repair and Replacement	NaN	NaN	Contractual Services	Bridge Construction/ Repair Services	NaN	County Road Aid	HIGHWAY SAFETY SERVICES	1692149	2016/03/31 03:59:59+00	5595.5	5595.5	846620	2016/04/25 03:59:59+00	9616.00	1900/01/01 05:00:00+00

	ObjectId	Fiscal_Year	Budget_Type	Agency_Name	Sub_Agency_Name	DepartmentName	Sub_DepartmentName	Category	Sub_Category	Stimulus_Type	Funding_Source	Vendor_Name	InvoiceID	InvoiceDt	InvoiceAmt	DistributionAmt	CheckID	CheckDt	CheckAmt	CheckVoidDt
97453	97454	2016	Metro Government Operations	Louisville Zoo	Visitor Services	Visitor Services	NaN	Supplies	Custodial Supplies	NaN	General Fund	SOUTHWEST JEFFERSON INC	1700693	2016/04/22 03:59:59+00	812.40	720.60	850473	2016/05/17 03:59:59+00	1292.00	1900/01/01 05:00:00+00
97454	97455	2016	Metro Government Operations	Louisville Zoo	Visitor Services	Visitor Services	NaN	Supplies	Custodial Supplies	NaN	General Fund	SOUTHWEST JEFFERSON INC	1700693	2016/04/22 03:59:59+00	812.40	91.80	850473	2016/05/17 03:59:59+00	1292.00	1900/01/01 05:00:00+00
97455	97456	2016	Metro Government Operations	Louisville Zoo	Visitor Services	Visitor Services	NaN	Supplies	Custodial Supplies	NaN	General Fund	SOUTHWEST JEFFERSON INC	1700694	2016/04/22 03:59:59+00	479.60	479.60	850473	2016/05/17 03:59:59+00	1292.00	1900/01/01 05:00:00+00
97456	97457	2016	Metro Government Operations	Louisville Zoo	Visitor Services	Visitor Services	NaN	Supplies	Custodial Supplies	NaN	General Fund	SOUTHWEST JEFFERSON INC	1720639	2016/06/27 03:59:59+00	812.40	812.40	862237	2016/07/22 03:59:59+00	812.40	1900/01/01 05:00:00+00
97457	97458	2016	Metro Government Operations	Louisville Zoo	Visitor Services	Visitor Services	NaN	Supplies	Custodial Supplies	NaN	General Fund	SOUTHWEST JEFFERSON INC	1713236	2016/06/10 03:59:59+00	719.40	719.40	859070	2016/07/05 03:59:59+00	719.40	1900/01/01 05:00:00+00
97458	97459	2016	Metro Government Operations	Louisville Zoo	Visitor Services	Visitor Services	NaN	Supplies	Custodial Supplies	NaN	General Fund	SOUTHWEST JEFFERSON INC	1711246	2016/05/27 03:59:59+00	541.60	541.60	857295	2016/06/24 03:59:59+00	541.60	1900/01/01 05:00:00+00
97459	97460	2016	Metro Government Operations	Louisville Zoo	Visitor Services	Visitor Services	NaN	Supplies	Custodial Supplies	NaN	General Fund	SOUTHWEST JEFFERSON INC	1714049	2016/06/03 03:59:59+00	541.60	541.60	858046	2016/06/28 03:59:59+00	541.60	1900/01/01 05:00:00+00
97460	97461	2016	Metro Government Operations	Louisville Zoo	Visitor Services	Visitor Services	NaN	Supplies	First Aid Supplies	NaN	General Fund	GRAINGER INDUSTRIAL SUPPLY	1676519	2016/02/04 05:00:00+00	95.85	95.85	836829	2016/02/29 05:00:00+00	3942.68	1900/01/01 05:00:00+00
97461	97462	2016	Metro Government Operations	Louisville Zoo	Visitor Services	Visitor Services	NaN	Supplies	First Aid Supplies	NaN	General Fund	GRAINGER INDUSTRIAL SUPPLY	1644089	2015/10/05 03:59:59+00	95.48	95.48	816769	2015/10/30 03:59:59+00	115.36	1900/01/01 05:00:00+00
97462	97463	2016	Metro Government Operations	Louisville Zoo	Visitor Services	Visitor Services	NaN	Supplies	First Aid Supplies	NaN	General Fund	GRAINGER INDUSTRIAL SUPPLY	1627704	2015/08/04 03:59:59+00	250.63	250.63	805212	2015/08/31 03:59:59+00	1574.76	1900/01/01 05:00:00+00

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Close Punctuation

Open Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks